SELECT department_id, TO_CHAR(null) AS DNAME, hire_date
FROM   employees
UNION
SELECT department_id, department_name, TO_DATE(null)
FROM   departments;
